<%@ page import="org.apache.catalina.User" %>
<%@ page import="java.util.ArrayList" %>
<%@ page import="java.sql.Connection" %>
<%@ page import="java.sql.Statement" %>
<%@ page import="java.util.List" %>
<%@ page import="java.sql.ResultSet" %>
<%@ page import="java.sql.DriverManager" %><%--
  Created by IntelliJ IDEA.
  User: dell
  Date: 2018/5/13
  Time: 22:09
  To change this template use File | Settings | File Templates.
--%>
<%@ page contentType="text/html;charset=UTF-8" language="java" %>
<html>
<head>
    <title>用户删除</title>
</head>
<body>

<style type="text/css">

    table {

        border-collapse: collapse;
    }

    td {

        border: 1px solid #000;
        padding: 10px;
    }
</style>

<table>
    <tr>
        <td>编号</td>
        <td>姓名</td>
        <td>密码</td>
        <td>操作1</td>
        <td>操作2</td>
    </tr>

    <%

        List<User> userList = new ArrayList<>();
        // 3+1
        Connection connection = null;
        Statement statement = null;
        ResultSet resultSet = null;

        // t_users
        String sql = "select * from t_users";

        Class.forName("com.mysql.jdbc.Driver");

        connection = DriverManager.getConnection(
                "jdbc:mysql://localhost:3306/sctu_javaweb_2018",
                "root",
                "sctu123456"
        );
        statement = connection.createStatement();

        resultSet = statement.executeQuery(sql);

        while(resultSet.next()){
            int id = resultSet.getInt(1);
            String username = resultSet.getString(2);
            String password = resultSet.getString(3);
        }

        resultSet.close();
        statement.close();
        connection.close();
        for (User user : userList) {
            out.write("<tr><td>" + session.getId() +
                    "</td><td>" + user.getName() +
                    "</td><td>" + user.getPassword() +
                    "</td><td>" +
                    "<a href='deleteUserHandler.jsp?id="
                    + session.getId() +"'>删除</a></td>" +
                    "<td><a href='updateUser.jsp?id="+ session.getId() +
                    "&username="+user.getName()+"&password="+user.getPassword()+
                    "'>更新</a></td></tr>");
        }
    %>
</table>

<%@include file="footer.jsp"%>
</body>
</html>
